Dynamic Text Examples
The following examples will use this grid query:
To read Australian sales as a raw numerical value
DATA(0,0)
To read German Profit as a formatted string value
FormattedData(3,1)
To multiple Canadian sales by Canadian margin
Data(1,0) * Data(1,4)
To sum the sales column
TotalColumn(0)
To get the average profit across all countries
Average(DataSetColumn(1))
To read the label "France"
Label(1,2,0)
To find the row with the highest value in column 3
LookupMaxRow(3)
To find the country label with the highest net profit
Label(1,LookupMaxRow(2) ,0)
To read German sales as a raw numerical value
DATA(3,1)
To format German profit as currency with no decimals
Format("C0", Data(3,1) )
To find the value of sales for the last item in the grid
Data(LastRow(),0)
If Australian net margin is higher than Canadian net margin, write 'good', otherwise 'bad'
Iff(Data(0,3) > Data(1,3) ,"good","bad")
To write out which country has the highest profit and the amount of profit, formatted with in currency with no decimals
"The country with the highest profit of " + Format("C0", Data(LookupMaxRow(1),1)) + " is " + Label(1,LookupMaxRow(1) ,0)
Home |
Table of Contents |
Index |
User Community
Pyramid Analytics © 2011-2022